﻿CREATE TABLE [dbo].[UDS_CM_Linkman] (
    [ID]              int          NOT NULL identity(1, 1),
    [ClientID]        int          NOT NULL,
    [Name]            nvarchar(50)  COLLATE Chinese_PRC_CI_AS NULL,
    [Mobile]          nvarchar(50)  COLLATE Chinese_PRC_CI_AS NULL,
    [Telephone]       nvarchar(50)  COLLATE Chinese_PRC_CI_AS NULL,
    [Position]        nvarchar(50)  COLLATE Chinese_PRC_CI_AS NULL,
    [Email]           nvarchar(50)  COLLATE Chinese_PRC_CI_AS NULL,
    [Gender]          bit          NULL,
    [Description]     nvarchar(500) COLLATE Chinese_PRC_CI_AS NULL,
    [Address]         nvarchar(100) COLLATE Chinese_PRC_CI_AS NULL,
    [Family]          nvarchar(200) COLLATE Chinese_PRC_CI_AS NULL,
    [LastContactTime] datetime     NULL,

    CONSTRAINT [PK_UDS_CM_Linkman] PRIMARY KEY CLUSTERED ([ID] asc)
);
GO
